<?php

//Rquire MySqlAdapter.
require_once(dirname(__FILE__).'/../db/MySqlAdapter.php');

class excelDBHandler {

 	/*************************************************************************
	*************************      Public Methods     ************************
	*************************************************************************/
	
		//This function returns a table containing student datails and gardes per events 
		public static function studentsToEvent()
		{
			return excelDBHandler::studentDetails();
		}
	
	/*****************       Private Methods        *******************/

	private static function studentDetails() {
		 $mysql_link = MySqlAdapter::get_mysql_link();
		 
		 $query = excelDBHandler::studentDetailsQuery();
		 $result = mysql_query($query, $mysql_link);	//Excecute the Query
		return $result;
		 
	}
	/*************************************************************************
	*************************   Queires Methods   ****************************
	*************************************************************************/

	private static function studentDetailsQuery()	
	{
		$query=
				"SELECT *
				 FROM `ohel_shelomo_2012`.`person`"
				 ;
		return $query;		
	}

}
?>